package dbschema

import (
	"git.sr.ht/~mil/mobsql/sqlgen"
)

var views = []sqlgen.View{
	{
		Name: "_vsources",
		Doc: `
				Internal tracking view mobsql uses to track against; joining the
				internal _mdb (mobility DB CSV) table against _mobsql table (load
				history). This is the root view that is used for status queries as
				well as the query SourceSet filters are built against.
			`,
		SQLSelectFile: "sqlviews/_vsources.sql",
	},
	{Name: "_vstopparent", Doc: "Mapping of stops to their parent stops", SQLSelectFile: "sqlviews/_vstopparent.sql"},
	{Name: "_vconnd", Doc: "CSA timetable", SQLSelectFile: "sqlviews/_vconnd.sql"},
	{Name: "_vconndverbose", Doc: "CSA timetable (with verbose joins)", SQLSelectFile: "sqlviews/_vconndverbose.sql"},
	{Name: "_vconndverbosewithextensions", Doc: "CSA timetable (with verbose joins AND go extensions)", SQLSelectFile: "sqlviews/_vconndverbosewithextensions.sql"},
	{Name: "_vcaltoservice", Doc: "Maps calendar dates individually to valid service id", SQLSelectFile: "sqlviews/_vcaltoservice.sql"},
	{Name: "_vtransferstbl", Doc: "Transfers table added with from/to idu (parents)", SQLSelectFile: "sqlviews/_vtransferstbl.sql"},
	{Name: "_vtransfersgen", Doc: "Transfers table generated from stops self-join", SQLSelectFile: "sqlviews/_vtransfersgen.sql"},
}
